package com.blog.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.blog.domain.entity.UserRole;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 用户和角色关联表(UserRole)表数据库访问层
 *
 * @author makejava
 * @since 2024-09-16 21:44:31
 */
@Mapper
public interface UserRoleMapper extends BaseMapper<UserRole> {
	@Select("select role_id from sys_user_role where user_id = #{id}")
	List<Long> getUserRoleIds(Long id);
}
